<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
	<title>HouDun许愿墙</title>
	<link rel="stylesheet" href="./Css/index.css" />
	<script type="text/javascript" src='./Js/jquery-1.7.2.min.js'></script>
	<script type="text/javascript" src='./Js/index.js'></script>
</head>
<body>
	<div id='top'>
		<span id='send'></span>
	</div>
	<div id='main'>
            <?php
            header("Content-type: text/html; charset=utf-8"); 
            $servername = "127.0.0.1";
            $username = "root";
            $password = "";
            $dbname = "wish";

            // 创建连接
            $conn = new mysqli($servername, $username, $password, $dbname);

            // 检测连接
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            } 
           
            $sql = "SELECT * from wish";
            $conn ->query("set names 'utf8'");
            $result = $conn->query($sql);
            $arrlist = array();

            if ($result->num_rows > 0) {
                // 输出每行数据
                while($row = $result->fetch_assoc()) {
                    array_push($arrlist,$row);
                    //echo "<br> id: ". $row["id"]. " - Name: ". $row["firstname"]. " " . $row["lastname"];
                }
            } else {
                echo "0 results";
            }    
           $conn->close();
            ?>   
        
            <?php 
            foreach ($arrlist as $vo){
            ?>
            <dl class='paper a1'>
                <dt>
                    <span class='username'><?php echo $vo['username'] ?></span>
                     <span class='num'>No.0000<?php echo $vo['id'] ?></span>   
                </dt>
                <dd class='content'> 
                    <?php echo $vo['content'] ?>
                </dd>
                <dd class="bottom">
                    <span class="tiom"><?php echo $vo['time_at'] ?></span>
                    <a href="" class='close'>
                    </a>
                </dd>
            </dl>	
            <?php } ?>
            
        </div>
            
            
            
	<div id='send-form'>
		<p class='title'><span>许下你的愿望</span><a href="" id='close'></a></p>
                <form action="" name='wish' method="git">
			<p> 
				<label for="username">昵称：</label>
				<input type="text" name='user' id='username'/>
			</p>
			<p>
				<label for="content">愿望：(您还可以输入&nbsp;<span id='font-num'>50</span>&nbsp;个字)</label>
				<textarea name="content" id='content'></textarea>
				<div id='phiz'>
					<img src="./Images/phiz/zhuakuang.gif" alt="抓狂" />
					<img src="./Images/phiz/baobao.gif" alt="抱抱" />
					<img src="./Images/phiz/haixiu.gif" alt="害羞" />
					<img src="./Images/phiz/ku.gif" alt="酷" />
					<img src="./Images/phiz/xixi.gif" alt="嘻嘻" />
					<img src="./Images/phiz/taikaixin.gif" alt="太开心" />
					<img src="./Images/phiz/touxiao.gif" alt="偷笑" />
					<img src="./Images/phiz/qian.gif" alt="钱" />
					<img src="./Images/phiz/huaxin.gif" alt="花心" />
					<img src="./Images/phiz/jiyan.gif" alt="挤眼" />
				</div>
                                
			</p>
                    <!--  span id='send-btn'></span -->
			<input type="submit" value="许愿"  />

		</form>
	</div>
<!--[if IE 6]>
    <script type="text/javascript" src="./Js/iepng.js"></script>
    <script type="text/javascript">
        DD_belatedPNG.fix('#send,#close,.close','background');
    </script>
<![endif]-->
</body>
</html>